import openpyxl
book = openpyxl.load_workbook("pp.xlsx")
shl = book["Sheet1"]
shl['D1'] = "pass"
shl.cell(5, 6).value = "fail"
new_row = ['cc', 'delete', 'kk']
shl.append(new_row)
book.save("pp.xlsx")